County Profile for Franklin - 2017



County Controls Information

Cost Report Counts Population
Total Hospital Count 1 Total Population on July 31, 2017 0
Total Cost Reports Filed in 2017 1 Total Births 0
Total Cost Reports Submitted 0 Total Deaths 0
Total Cost Reports Settled 0 Net Population Natural Change 0
Total Cost Reports Reopened 1 Total International Migration 0
Total Cost Reports Ammended 0 Total Domestic Migration 0
Total Cost Reports Audited 0 Total Residual 0
Net Population Change 0

County Financial Statements - Worksheet G

Balance Sheet Income Statement
Current Assets 22,657,392 Total Charges 231,445,630
Fixed Assets 55,150,464 Contract Allowance 139,200,385
Other Assets 1,745,050 Operating Revenue 92,245,245
Total Assets 79,552,906 Operating Expenses 98,612,345
Current Liabilities 13,771,269 Operating Margin -6,367,100
Long Term Liabilities 31,685,731 Other Income 6,160,463
Total Equity 34,095,906 Other Expense 0
Total Liabilities and Equity 79,552,906 Net Profit or Loss -206,637

County Calculations

Per Discharge Statistics Per Bed Statistics Per Person Statistics
Revenue per Discharge $19,606 Revenue per Bed $1,098,158 Revenue per Person $92,245,245
Net Margin per Discharge ($1,353) Net Margin per Bed ($75,799) Net Margin per Person ($6,367,100)
Net Profit per Discharge ($44) Net Profit per Bed ($2,460) Net Profit per Person ($206,637)
Net Fixed Assets per Discharge $11,722 Net Fixed Assets per Bed $656,553 Net Fixed Assets per Bed $55,150,464
Long Term Debt per Discharge $6,734 Long Term Debt per Bed $377,211 Long Term Debt per Person $31,685,731
Persons per Discharge 0 Persons per Bed 0
Occupancy Rate 59.0 %
Length of Stay 4 Days

County Ranking of Selected Values

Income Statement Balance Sheet Statistics
Total Charges 1,075 Net Fixed Assets 895 Population Estimate 1,151
Total Revenue 990 Long Term Liabilities 818 Total Patient Discharges 829
Net Margin 2,704 Total Patient Beds 1,000
Net Profit or Loss 2,488

County Charges and Direct Cost - Worksheet B and C

Line Description Direct Cost Charges Ratio
30 Adults and Pediatrics - General Routine Care 24,042,596 22,838,953 1.0527
31 Intensive Care Unit 2,706,036 1,734,140 1.5604
32 Coronary Care Unit 0 0
43 Nursery 901,944 1,542,470 0.5847
44 Skilled Nursing Care 0 0
50 Operating Room 3,137,892 4,761,252 0.6590
51 Recovery Room 2,359,208 4,607,334 0.5121
52 Labor and Delivery Room 453,003 4,908,762 0.0923

County General Service Cost - Worksheet A

Lines Description Amount Lines Description Amount
01 Capital Related - Building and Fixtures 3,799,947 13 Nursing Administration 1,096,358
02,03 Captial Related - Movable Equipment 2,177,546 14 Central Services and Supply 6,329,383
04 Employee Benefits 8,448,174 15 Pharmacy 6,001,636
05 Administrative and General 17,575,546 16 Medical Records and Medical Library 649,758
06 Maintenance and Repairs 4,357,771 17 Social Services 221,132
07 Operation of Plant 0 18 Other General Service Expense 0
08,09 Laundry, Linen and Housekeeping 1,653,196 19 Non Physician Anesthetist 0
10,11 Dietary and Cafeteria 1,337,881 20,21,22,23 Education Programs 0
Total General Service Cost Centers 53,648,328

County Profile for Franklin - 2017